﻿using System.Data;
using System.Data.SQLite;
using System.Text;
using NDK.Utils;

namespace NDK.Module.DAL
{
    class ModifyROIServices
    {
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(string UserName,string modifyROI,string time)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into ModifyROI(");
            strSql.Append("UserName,ModifyROI,Time)");
            strSql.Append(" values (");
            strSql.Append("@UserName,@ModifyROI,@Time)");
            SQLiteParameter[] parameters = {
					new SQLiteParameter("@UserName", DbType.String,50),
					new SQLiteParameter("@ModifyROI", DbType.String,50),
					new SQLiteParameter("@Time", DbType.String,50)};
            parameters[0].Value = UserName;
            parameters[1].Value = modifyROI;
            parameters[2].Value = time;
            SQLiteUtils.ExecuteSql(strSql.ToString(), parameters);
        }
    }
}
